What are JOINS and how to use them?
May 24th, 2016
The JOIN keyword is used in a MySQL statement to query data from two or more tables...
MySQL Combining Queries
How to combine result with UNION operator?
May 24th, 2016
In order to combine two or more result sets into one, and thus increase readability and speed up querying, the UNION operator may be used.
Syntax
The basic syntax...
Matching rows from different tables with INNER JOIN clause
May 24th, 2016
The INNER JOIN clause let us match rows with same columns from two different tables. Following rules have to be applied to use the INNER JOIN clause:
It mus...
Matching data from different database tables with LEFT JOIN (RIGHT JOIN) clause
May 24th, 2016
The LEFT JOIN clause allows us to match...
Creating Table where table joins itself with Self JOIN
May 24th, 2016
The SELF-JOIN is relationship where the match fields are in same table. Here a table is joined with itself when table has a
UPDATE a database with values of another database by JOIN Clause
May 24th, 2016
To change data of an already created table UPDATE is used. The UPDATE statement
DELETE Statements and JOIN clause
May 24th, 2016
In some situations, where the data to be deleted are known only after combining databases with ...
What is ON DELETE CASCADE?
May 24th, 2016
When user wants to delete data from child tables, whenever the data is deleted from parent table, on
